home *** CD-ROM | disk | FTP | other *** search
/ Supercompiler 1997 / SUPERCOMPILER97.iso / BC++ Builder / DATA.Z / AMOUNTDU.SQL < prev    next >
Encoding:
Text File  |  1997-02-10  |  150 b   |  5 lines
  1. select Company, Sum(ItemsTotal) - Sum(AmountPaid) as AmountDue
  2.   from customer, orders
  3.   where Customer.CustNo = Orders.CustNo
  4.   group by Company
  5.